Tabela Co_Registration

Definicja tabeli Co_Registration

Name

Co_Registration

Code

Co_Registration

Comment

Tabela stanów meldunkowych


Lista kolumn tabeli Co_Registration

Name

Code

Co_RegistrationId

Co_RegistrationId

PatientId

PatientId

Info

Info

RegistrationDt

RegistrationDt

LocationID

LocationID

OrgUnitID

OrgUnitID

RoomId

RoomId

Co_DictDietId

Co_DictDietId


Kolumna Co_RegistrationId tabeli Co_Registration

Definicja kolumny Co_RegistrationId tabeli Co_Registration

Name

Co_RegistrationId

Code

Co_RegistrationId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator stanu meldunkowego danego pacjenta


Kolumna PatientId tabeli Co_Registration

Definicja kolumny PatientId tabeli Co_Registration

Name

PatientId

Code

PatientId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator pacjenta (tabela Person)


Kolumna Info tabeli Co_Registration

Definicja kolumny Info tabeli Co_Registration

Name

Info

Code

Info

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

dodatkowe informacje o zleconej diecie


Kolumna RegistrationDt tabeli Co_Registration

Definicja kolumny RegistrationDt tabeli Co_Registration

Name

RegistrationDt

Code

RegistrationDt

Data Type

DATE

Mandatory

Yes

Comment

data meldunku


Kolumna LocationID tabeli Co_Registration

Definicja kolumny LocationID tabeli Co_Registration

Name

LocationID

Code

LocationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrgUnitID tabeli Co_Registration

Definicja kolumny OrgUnitID tabeli Co_Registration

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RoomId tabeli Co_Registration

Definicja kolumny RoomId tabeli Co_Registration

Name

RoomId

Code

RoomId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Co_DictDietId tabeli Co_Registration

Definicja kolumny Co_DictDietId tabeli Co_Registration

Name

Co_DictDietId

Code

Co_DictDietId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Co_Registration

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Co_Registration

Definicja klucza Identifier_1 tabeli Co_Registration

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment